﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ConfirmReservation.aspx.cs" Inherits="RestHouseReservation.ConfirmReservation" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
	<meta http-equiv="content-type" content="text/html;charset=utf-8" />
	<link rel="shortcut icon" href="images/favicon.ico" />

	<style type="text/css">
		@import url(stylesheets/dark/styles.css);		/*link to the main CSS file */
	</style>
	<!-- Initialise jQuery Library -->
	<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
	<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>

	<title>Inspiration | Services page</title>

</head>
<body id="sp">
<!-- Start Main Nav -->
<div class="mainnav_full">
	<div id="MainNav">
		<a href="index.html" class="logo"><img src="images/logo.png" width="180" height="50" alt="" /></a>
		<div id="menu">
			<ul class="ddsmoothmenu">
				<li><span class="menuslide"></span><a href="AdminPage.aspx" title="Home">Home<span class="menu_description">Beginning</span></a>
                	
                </li>
				<li><span class="menuslide"></span><a href="ConfirmReservation.aspx" title="Gallery">ConfirmReservation<span class="menu_description">Our Gallery</span></a></li>
				<li><span class="menuslide"></span><a href="PendingRequests.aspx" title="Gallery">ConfirmRequests<span class="menu_description">Our Gallery</span></a></li>
                <li><span class="menuslide"></span><a href="UpdateUser.aspx" title="Gallery">Update Users<span class="menu_description">Our Gallery</span></a></li>
				<!--<li><span class="menuslide"></span><a href="portfolio_1col.html" title="Portfolio">Portfolio<span class="menu_description">Our Portfolio</span></a>
					<ul>
						<li><a href="portfolio_1col.html" title="Portfolio 1 Column">Portfolio 1 Column</a></li>
						<li><a href="portfolio_2col.html" title="Portfolio 2 Column">Portfolio 2 Column</a>
						<ul>
							<li><a href="portfolio_1col.html" title="Portfolio 1 Column">Portfolio 1 Column</a></li>
							<li><a href="portfolio_2col.html" title="Portfolio 2 Column">Portfolio 2 Column</a>
							<ul>
								<li><a href="portfolio_detailed.html" title="Portfolio Detailed">Portfolio Detailed</a></li>
							</ul>
							</li>
							<li><a href="portfolio_3col.html" title="Portfolio 3 Column">Portfolio 3 Column</a></li>
							<li><a href="portfolio_4col.html" title="Portfolio 4 Column">Portfolio 4 Column</a></li>
						</ul>
						</li>
						<li><a href="portfolio_3col.html" title="Portfolio 3 Column">Portfolio 3 Column</a></li>
						<li><a href="portfolio_4col.html" title="Portfolio 4 Column">Portfolio 4 Column</a></li>
						<li><a href="portfolio_single.html" title="Portfolio Detailed">Portfolio Detailed</a></li>
					</ul>
				</li>-->
				<li><span class="menuslide"></span><a href="AdminHome.aspx" title="Blog">LogOut<span class="menu_description"></span></a>
					<!--<ul>
						<li><a href="blog.html" title="Blog Page">Blog Page</a></li>
						<li><a href="blog_alternate.html" title="Blog Alternate Page">Blog Alternate Page</a></li>
						<li><a href="blog_single.html" title="Blog Single Page">Blog Single Page</a></li>
					</ul>-->
				</li>
				
			</ul>
		</div>
		<div class="clear"></div>
	</div>
</div>
<!-- End Main Nav -->

<!-- Begin Header -->
<div class="header_full sample_01">
	<div class="head_top_shadow"></div>
	<div class="head_bot_shadow"></div>
	<div id="header"></div>
</div>
<!-- End Header -->

<!-- Start Content Wrapper -->
<div class="content_wrapper">
	<div class="PageTitle">
		<h1>Services</h1>
	</div>
	<div id="breadcrumbs">
		<a href="index.html" title="Home">Home</a> &raquo; <a href="about.html" title="About Us">About Us</a> &raquo; Services
	</div>
	<!-- Content Area -->
	<div id="content">
<form id="form1" runat="server"> 
<%if (List[0].PaNumber != "empty")
  {%>
	<%for (int i = 0; i < length; i++)
   {%>
     Name:<%Response.Write(List[i].Name); %>
     <br/>
     PA Number:<%Response.Write(List[i].PaNumber); %>
     <br/>
     Rank:<%Response.Write(List[i].Rank); %>
     <br/>
     CheckIn:<%Response.Write(List[i].CheckIn); %>
     <br/>
     CheckOut:<%Response.Write(List[i].CheckOut); %>
     <br/>
     Required Room Type:<%Response.Write(List[i].RoomType); %>
     <br/>
     <b>Request Id:<%Response.Write(List[i].RequestId); %></b>
     <br/>
     <br/>
     <br/>
    <%
   }%>
   <%if (flag)
     {%>
  
<b>Select The Room Type:</b><br/>
<asp:DropDownList ID="DropDownList1" runat="server" 
    DataSourceID="SqlDataSource1" DataTextField="RoomNo" DataValueField="RoomNo">
</asp:DropDownList>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ReservationConnectionString %>" 
    SelectCommand="SELECT [RoomNo] FROM [RestHouseM] WHERE ([ReservedFor] = @ReservedFor)">
     <SelectParameters>
         <asp:Parameter DefaultValue="None" Name="ReservedFor" Type="String" />
     </SelectParameters>
</asp:SqlDataSource>

<br/><br/>

<b>Select The Request Id:</b><br/>
<asp:DropDownList ID="DropDownList2" runat="server" 
    DataSourceID="SqlDataSource2" DataTextField="RequestId" 
    DataValueField="RequestId">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ReservationConnectionString %>" 
    SelectCommand="SELECT [RequestId] FROM [Reservation] WHERE ([Status] = @Status)">
    <SelectParameters>
        <asp:Parameter DefaultValue="Pending" Name="Status" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
<br/><br/>
<asp:Button ID="Button1" runat="server" Text="Submit" onclick="Button1_Click" />
       
     <%}
     else
     {
         Response.Write("Sorry Reservation Can Not Be Performed Because No Room Is Available"); 
     } %>
 <% }
      %>
 <%else
  {
      Response.Write("Sorry No Pending Requests Available...!!!");
  } %>

    </form>
		<div class="hr"></div>
		<div class="columns">
			<div class="column">
				<h2 class="icon web">Works Everywhere</h2>
				<p>Donec accumsan malesuada orcidonec sitmet<br>eros lorem isum dolor amet incon. Adipiscing elit maurise pharetra magna accumsan. Malesuada orcdonec umet lorem doloronsec.</p>
			</div>
			<div class="column">
				<h2 class="icon graph">Easy to Customize</h2>
				<p>Donec accumsan malesuada orcidonec sitmet<br>eros lorem isum dolor amet incon. Adipiscing elit maurise pharetra magna accumsan. Malesuada orcdonec umet lorem doloronsec.</p>
			</div>
			<div class="column">
				<h2 class="icon book">Full Documentation</h2>
				<p>Donec accumsan malesuada orcidonec sitmet<br>eros lorem isum dolor amet incon. Adipiscing elit maurise pharetra magna accumsan. Malesuada orcdonec umet lorem doloronsec.</p>
			</div>
			<div class="clear"></div>
		</div>
	</div>
</div>
<!-- End Content Wrapper -->

<!-- End Footer Sidebar -->
<!-- Start Footer  -->
<div class="footer_full">
	<div id="footer">
		<div class="copy">
			<p>Copyright &copy; 2011  &bull; RV&FC  &bull;  All rights reserved</p>
			<p class="developed_by">Developed By: Muhammad Ammar Ali</p>
		</div>
		<div class="social">
			<a href="http://www.facebook.com/people/@/MixerTheme" title="Facebook"><img src="images/facebook.png" width="42" height="42" alt="" /></a>
			<a href="http://themeforest.net/user/MixerTheme/portfolio" title="Myspace"><img src="images/myspace.png" width="42" height="42" alt="" /></a>
			<a href="feed://themeforest.net/feeds/users/MixerTheme" title="RSS Feed"><img src="images/rss.png" width="42" height="42" alt="" /></a>
			<a href="http://twitter.com/MixerTheme" title="Twitter"><img src="images/twitter.png" width="42" height="42" alt="" /></a>
		</div>
		<div class="clear"></div>
	</div>
</div>
<!-- End Footer  -->

<!-- Theme Hook -->
<script type="text/javascript" src="js/common.js"></script>

<!-- End Control Panel -->
</body>
</html>
